<?php if (!defined('BASEPATH')) exit('No direct script access allowed');

/**
 * Adminlog Controller
 * Build by Phuc Nguyen
 * Contact : nguyenvanphuc0626@gmail.com
 */

class Others_model extends MY_Model{
	
	public function __construct(){
		parent::__construct();
		//$this->table_name = 'book_telecom';
	}
	
        public function getInfoPnrTicket($booking_place_code){
                $this->db->select('bc.name,bc.address,blb.sale_fare,blb.booking_place_code,usr.firstname');
                $this->db->from('book_list_booking AS blb');
                $this->db->where('blb.booking_place_code',$booking_place_code);
                $this->db->join('users AS usr','usr.id = blb.owner');
                $this->db->join('book_contacts AS bc','bc.customerID = blb.customerID');
                $query = $this->db->get();
		return $query->result();
        }
}